This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
Accessing a NotesSQL Datasource from MS SQL Server
Here's a little more detail:
I am able to query data from the NotesSQL datasource from Mangement Studio in both of the following ways:
1) select * from openquery(NotesSQL, 'Select * from frmTest')
2) select * from NotesSQL...frmTest
Both work, but what I am still unable to use an SQL update statement. And what I really need is to be able to update Notes data from SQL Server.
When I try an update statement, I get the following message:
Msg 7390, Level 16, State 2, Line 1
The requested operation could not be performed because OLE DB provider "MSDASQL" for linked server "NotesSQL" does not support the required transaction interface.
From everything I can tell in the NotesSQL documentation, update statements are supported. So, I assume it's just a matter of finding the right syntax here.
Again, if anyone could shed some light here, I'd appreciate it.
Feedback response number WEBB7ZMSL4 created by ~Frank Elgerovergon on 01/12/2010
Accessing a NotesSQL Datasource from MS SQL Server
Return to top
. . Accessing a NotesSQL Datasource fro... (~Frank Elgerove... 12.Jan.10) 
